home *** CD-ROM | disk | FTP | other *** search
/ Amiga Tools 3 / Amiga Tools 3.iso / wb-tools / db2.9 / examples / arexxdemos / timefield.db < prev    next >
Encoding:
Text File  |  1994-11-20  |  281 b   |  12 lines
  1. /* Rexxprogram for db to convert a field to a "time field".
  2.  * By Anders Callertun 1994
  3.  */
  4.  
  5. options results
  6. GETFIELD
  7. time = result
  8. if pos(':',time)=0 & length(time)<5 then do
  9.     if length(time)<3 then time = right(time,3,'0')
  10.     PUTFIELD left(time,length(time)-2)':'right(time,2)
  11. end
  12.